<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">

<html>

<head>
<title>Sans Titre</title>
<meta http-equiv="content-type" content="text/html; charset=iso-8859-1" />
<meta name="generator" content="HAPedit 3.1">
</head>
<body bgcolor="#FFFFFF">
<?

 include "connect.php";
  $sel="select * from member where mid=".$_GET["q"]."";
  $rs=mysql_query($sel);
  $arr=mysql_fetch_array($rs);
  $sel1="select hvalue from hobby where mid=".$_GET["q"]."";

  $rss=mysql_query($sel1);




?>
<table border=1>
       <tr>
           <td>Name</td>
           <td><? echo $arr[4]?></td>
       </tr>
       <tr>
           <td>E-Mail:</td>
           <td><? echo $arr[1]?></td>
       </tr>
       <tr>
             <td>Sex</td>
             <td><input type="radio" name=optsex value="Male"<? echo ($arr[2]=="Male")?checked:""?> >Male
             <input type="radio" name=optsex value="Female" <? echo ($arr[2]=="Feale")?checked:""?>>Female</td>
       </tr>
       <tr>
           <td>Photo</td>
           <td><img src=<? echo $arr[3]?> height="100px" width="100px" ></td>
       </tr>
       <tr>
           <td>Hobbies</td>
           <td>
           <?
           while($newarr=mysql_fetch_array($rss))
           {
           ?>

                    <input type="checkbox" name="game[]" value=<? echo $newarr[0]?> checked><? echo $newarr[0]?>


           <?}?>
           </td>
       </tr>

</table>
</body>

</html>

